﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//Please add references
namespace QunYing.DAL
{
    /// <summary>
    /// 数据访问类:Notice
    /// </summary>
    public partial class Notice
    {
        /// <summary>
        /// 公告
        /// </summary>
        /// <returns></returns>
        public DataTable GetNotice()
        {
            const string strSql = "select * from dbo.Notice where 是否过期=0 order by 显示顺序 asc,发布时间 desc";

            return DbHelperSQL.Query(strSql).Tables[0];
        }
    }
}

